<head>
    <!--Load the AJAX API-->
    <script type="text/javascript" src="http://www.google.com/jsapi"></script>
    <script type="text/javascript">
    
      // Load the Visualization API and the piechart package.
      //google.load('visualization', '1', {'packages':['piechart']});
      google.load('visualization', '1', {'packages':['piechart', 'table', 'columnchart']});
      // Set a callback to run when the Google Visualization API is loaded.
      google.setOnLoadCallback(drawChart);
      
      // Callback that creates and populates a data table, 
      // instantiates the pie chart, passes in the data and
      // draws it.
      function drawChart() {

      // Create our data table.
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Piece s Name');
        data.addColumn('number', 'number of vote');
        <?php $i=0;?>
        data.addRows([
          <?php foreach($query_best_expo->result() as $row){?>
          <?php if($i != 0){echo ',';}?>
		  ['<?php echo $row->name?>',<?php echo $row->nb?>]
				  <?php $i=$i+1;?>
<?php } ?>

        ]);

        // Instantiate and draw our chart, passing in some options.
        var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
        chart.draw(data, {width: 400, height: 240, is3D: true, title: 'Statistic on best pieces'});

        var table = new google.visualization.Table(document.getElementById('table'));
        table.draw(data, {width: 400, height: 240});

        google.visualization.events.addListener(table, 'select', function() {
            chart.setSelection(table.getSelection());
          });

        google.visualization.events.addListener(chart, 'select', function() {
            table.setSelection(chart.getSelection());
          }); 
        }
    </script>
  </head>

  <body>
    <!--Div that will hold the pie chart-->
    <div id="chart_div"></div>
    
     <!--Div that will hold the table chart-->
    <div id="table"></div>
    

  </body>


<h1>Statistic</h1>
<ul>
<?php foreach($query_best_expo->result() as $row){?>
			<li>  <?php echo $row->name?>   nb de vote : <?php echo $row->nb?></li>
<?php } ?>
</ul>